Previous Topic

Next Topic

Database schema for card authorization accounts and cash accounts

Card authorization account information and cash account information is kept in the following iMIS tables.

Card authorization accounts using the VeriSign gateway

The following columns in the CCAuthAcct table are used for each VeriSign card authorization account:

Column

Data Type

Description

CCAuthAcctCode

varchar (20)

The code for the card authorization account

CCAuthAcctDescription

varchar (255)

Description associated with an account code

CCAuthMode

tinyint

Authorization mode: 0 (manual), 1 (immediate), or 3 (deferred)

CCAuthAdminEmail

varchar (255)

E-mail address of the system administrator responsible for setting up the accounts

CCAuthUrl

varchar (255)

URL of the test or live site

CCAuthGateway

varchar (255)

Gateway interface through which card authorization occurs (Verisign)

CCAuthPort

int

Port address used for VeriSign transaction processing

CCAuthUser

varchar (255)

Username created during setup process

CCAuthPassword

varchar (255)

Password created during VeriSign sign-up process

CCAuthVerisignPartner

varchar (255)

Partner name supplied by VeriSign

CCAuthVerisignVendor

varchar (255)

Vendor name supplied by VeriSign

CCAuthTimeout

int

Timeout period supplied by VeriSign

CCAuthVerisignProxyServer

varchar (255)

VeriSign proxy server supplied by network administrator

CCAuthVerisignProxyPort

varchar (255)

VeriSign proxy port supplied by network administrator

CCAuthVerisignProxyUser

varchar (255)

VeriSign proxy user ID supplied by network administrator

CCAuthVerisignProxyPassword

varchar (255)

VeriSign proxy password supplied by network administrator

CCAuthSaveCscBeforeAuth

tinyint

Handling of CSC value for deferred authorization: 0 (do not save CSC in iMIS) or 1 (save encrypted CSC in iMIS then delete after successful authorization)

Card authorization accounts using the QSI gateway

The following columns in the CCAuthAcct table are used for each QSI card authorization account:

Column

Data Type

Description

CCAuthAcctCode

varchar (20)

The code for the card authorization account

CCAuthAcctDescription

varchar (255)

Description associated with an account code

CCAuthMode

tinyint

Authorization mode: 0 (manual), 1 (immediate), or 3 (deferred)

CCAuthAdminEmail

varchar (255)

E-mail address of the system administrator responsible for setting up the accounts

CCAuthGateway

varchar (255)

Gateway interface through which card authorization occurs (QSI)

CCAuthUser

varchar (255)

QSI Merchant ID created during setup process

CCAuthVerisignPartner

varchar (255)

QSI Merchant Administration login (username) obtained from QSI/Dialect during setup process

CCAuthPassword

varchar (255)

QSI Merchant Administration login (username) password obtained from QSI/Dialect during setup process

CCAuthSaveCscBeforeAuth

tinyint

Handling of CSC value for deferred authorization: 0 (do not save CSC in iMIS) or 1 (save encrypted CSC in iMIS then delete after successful authorization)

Card authorization accounts using the Other gateway

The following columns in the CCAuthAcct table are used for each Other card authorization account:

Column

Data Type

Description

CCAuthAcctCode

varchar (20)

The code for the card authorization account

CCAuthAcctDescription

varchar (255)

Description associated with an account code

CCAuthMode

tinyint

Authorization mode: 0 (manual), 1 (immediate), or 3 (deferred)

CCAuthGateway

varchar (255)

Gateway interface through which card authorization occurs (Other)

CCAuthSaveCscBeforeAuth

tinyint

Handling of CSC value for deferred authorization: 0 (do not save CSC in iMIS) or 1 (save encrypted CSC in iMIS)

Cash accounts for credit/debit cards

The following columns in the Cash_Accounts table are used for each credit/debit card cash account:

Column

Data Type

Description

CCAuthAcctCode

varchar (20)

The code for the card authorization account

CSC_REQUIRED_WEB

bit

Indicates whether the CSC value is required in e-Series: 0 (not required) or 1 (required)

CSC_REQUIRED_CS

bit

Indicates whether the CSC value is required in iMIS: 0 (not required) or 1 (required)

ISSUE_NO_FLAG

tinyint

Indicates whether the Issue Number field should be displayed in iMIS payment entry windows: 0 (not displayed) or 1 (displayed)

ISSUE_DATE_FLAG

tinyint

Indicates whether the Issue Date field should be displayed in iMIS payment entry windows: 0 (not displayed) or 1 (displayed)

See Also

Setting up card authorization

Installing iMIS and adding license keys

AR/Cash Credit Card Authorization window

Requiring a Card Security Code (CSC) for credit/debit card transactions

Setting up credit/debit card cash accounts in AR/Cash

Accepting and validating Diners Club and Carte Blanche credit cards

Setting up multiple card authorization accounts

Customizing credit card expiration dates for e-Series

Setting up authorization options in Fund Raising

Setting up European debit card authorization

Setting up a card authorization account for non-iMIS authorization


ASI logo 10.6 Production Release. Updated 3/20/2006 3:45:05 PM
© 2009 by Advanced Solutions International, Inc. All rights reserved.